Tabela CO_DELIVERYITEM

Definicja tabeli CO_DELIVERYITEM

Name

CO_DELIVERYITEM

Code

CO_DELIVERYITEM

Comment

Tabela pozycji wydania


Lista kolumn tabeli CO_DELIVERYITEM

Name

Code

CO_DELIVERYITEMID

CO_DELIVERYITEMID

CO_DELIVERYID

CO_DELIVERYID

CO_DISHID

CO_DISHID

QUANTITY

QUANTITY

MEALTYPEID

MEALTYPEID

INSERTDATE

INSERTDATE

INSERTINGPERSON

INSERTINGPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDDT

LASTMODIFIEDDT


Kolumna CO_DELIVERYITEMID tabeli CO_DELIVERYITEM

Definicja kolumny CO_DELIVERYITEMID tabeli CO_DELIVERYITEM

Name

CO_DELIVERYITEMID

Code

CO_DELIVERYITEMID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

klucz g??????wny


Kolumna CO_DELIVERYID tabeli CO_DELIVERYITEM

Definicja kolumny CO_DELIVERYID tabeli CO_DELIVERYITEM

Name

CO_DELIVERYID

Code

CO_DELIVERYID

Data Type

NUMBER(10)

Mandatory

No

Comment

klucz obcy do CO_DELIVERY


Kolumna CO_DISHID tabeli CO_DELIVERYITEM

Definicja kolumny CO_DISHID tabeli CO_DELIVERYITEM

Name

CO_DISHID

Code

CO_DISHID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

identyfikator dania, klucz obcy do CO_DISH


Kolumna QUANTITY tabeli CO_DELIVERYITEM

Definicja kolumny QUANTITY tabeli CO_DELIVERYITEM

Name

QUANTITY

Code

QUANTITY

Data Type

NUMBER(20,8)

Mandatory

Yes

Comment

ilo?????? wydanych da???


Kolumna MEALTYPEID tabeli CO_DELIVERYITEM

Definicja kolumny MEALTYPEID tabeli CO_DELIVERYITEM

Name

MEALTYPEID

Code

MEALTYPEID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

identyfikator posi???ku, klucz obcy do MealType


Kolumna INSERTDATE tabeli CO_DELIVERYITEM

Definicja kolumny INSERTDATE tabeli CO_DELIVERYITEM

Name

INSERTDATE

Code

INSERTDATE

Data Type

DATE

Mandatory

No

Comment

 


Kolumna INSERTINGPERSON tabeli CO_DELIVERYITEM

Definicja kolumny INSERTINGPERSON tabeli CO_DELIVERYITEM

Name

INSERTINGPERSON

Code

INSERTINGPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDPERSON tabeli CO_DELIVERYITEM

Definicja kolumny LASTMODIFIEDPERSON tabeli CO_DELIVERYITEM

Name

LASTMODIFIEDPERSON

Code

LASTMODIFIEDPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDDT tabeli CO_DELIVERYITEM

Definicja kolumny LASTMODIFIEDDT tabeli CO_DELIVERYITEM

Name

LASTMODIFIEDDT

Code

LASTMODIFIEDDT

Data Type

DATE

Mandatory

No

Comment

 


Lista kluczy tabeli CO_DELIVERYITEM

Name

Code

Primary

PK_CO_DELIVERYITEM

PK_CO_DELIVERYITEM

X


Klucz PK_CO_DELIVERYITEM tabeli CO_DELIVERYITEM

Definicja klucza PK_CO_DELIVERYITEM tabeli CO_DELIVERYITEM

Name

PK_CO_DELIVERYITEM

Code

PK_CO_DELIVERYITEM

Primary

Yes

Comment